# -*- coding: utf-8 -*-
# @Time    : 2024/3/17 21:10
# @Author  : 顾安
# @File    : create_table.py
# @Software: PyCharm


from feapder.db.mysqldb import MysqlDB


db = MysqlDB(ip='localhost', port=3306, user_name='root', user_pass='root', db='py_spider')

sql = """
    create table if not exists douban_feapder(
        id int primary key auto_increment,
        title varchar(255) not null,
        score varchar(255) not null,
        detail_url varchar(255) not null,
        detail_text text
    );
"""

db.execute(sql)
